SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018948 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018948 [ RunTime:0.003715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958199,845513,166170,484274,571648,455307,984486,327072,632241,101178,245680,389807,831090,799609,953052,224366,1026364,558297,828099,529427,296115,259709,537216,362475,516903,276871,30015,280790,702095,247121,809770,41335,444811,894027,271873,792784,502173,712866,560461,20654,277702,114338,539753,609031,1016885,959080,546171,565701,911019,1329,3978,596696,631900,157272,110829,818480,1045997,86075,829641,664932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]