SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106918 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106918 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810541,894495,215636,822513,610090,614666,536527,581608,771989,535278,734225,127923,659585,550889,159542,452432,287091,884577,660591,594945,353306,564295,277649,941949,262221,642757,749307,544967,944650,207398,96960,26680,809051,807397,388910,925641,621851,89685,516141,89764,649169,850222,706551,242932,810366,3648,896235,97016,853553,994416,251797,993413,875671,98872,47869,671512,725442,9085,966013,490842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]