SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543273 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543273 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56325,928449,800917,1008006,193943,897873,170737,470449,769023,959479,630821,245061,636920,259266,1040960,438151,229746,204218,351672,627297,192397,247008,805866,974262,601942,769439,928180,126127,850820,568636,1048698,641644,1010469,252099,504822,420774,702337,915497,180974,117546,543888,196089,230343,567527,506945,292856,999001,564132,2306,406824,1029045,967447,437951,238183,412742,491255,665064,781539,416630,235435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]