SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335024 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335024 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736668,812957,1006352,568264,962148,250780,688832,505203,988355,1000156,291620,981299,349972,283014,881170,7429,843816,7666,561170,834597,319617,925595,887537,745718,774212,309819,251155,782236,933650,790106,741892,416091,558387,738060,687654,593184,393208,712079,558526,139653,271169,719383,724957,678199,38369,988640,326888,608558,471958,977392,102858,1046125,446350,103151,297143,753815,194268,228118,618175,711736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000805s ]