SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52856 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52856 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024966,801235,262585,599049,14738,5220,93020,67992,92364,429209,166460,83730,405066,968776,1004808,471902,49153,607745,742329,97741,999865,770376,907828,545449,609555,1033666,393613,310673,261386,798218,478501,1048776,99978,188653,650317,677314,137408,413832,986531,455341,735604,558030,706647,1013764,748593,535436,432174,156037,3768,435707,1048905,880250,268085,806319,476398,16396,573984,84338,645918,212153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]