SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101040 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101040 [ RunTime:0.003491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575565,105115,19502,914596,906208,298995,921164,439783,77859,1044207,689234,326152,41165,896595,586476,82051,559282,452373,836040,747807,675181,1019186,169704,663858,553641,727879,527649,537628,818192,648395,441961,960678,671693,719894,892943,965969,777593,651713,493712,180354,28178,127169,963402,679718,580244,3990,349625,187833,85362,370101,181782,619121,430996,64274,264249,544057,854286,673570,173561,520196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]