SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017251 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017251 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586134,37245,528599,187095,270164,793933,128844,586233,880248,68067,633443,555013,112374,676563,660606,356405,694555,58643,512220,363759,702923,744315,138885,485557,735611,746030,133768,9735,13956,723717,950669,502991,310376,561579,616288,984568,775546,168680,185111,536426,852131,671792,87693,495797,515784,892391,212028,543660,396324,704576,618399,166526,204546,548773,895849,165718,607949,449016,728149,809465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002124s ]