SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456099 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456099 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357827,1045834,796056,777346,129746,806285,696029,143703,808998,205515,138132,291379,873902,43407,888872,246605,226487,730839,221026,687763,750496,200239,729289,126709,28976,281166,12515,67239,503899,151133,882770,522681,3383,629105,674592,872051,824723,473050,1006481,152480,466635,809820,656002,69323,204189,674546,232752,366380,133412,277215,321203,478972,333827,391262,257238,329087,594738,24280,116246,227299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]