SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330912 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330912 [ RunTime:0.003122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169563,57069,470649,32962,43651,341906,901420,70724,850985,226149,784611,24397,685444,870942,210351,112247,975973,490456,335215,480966,801580,901896,389488,649244,33850,902682,621590,432604,245436,659837,971344,807931,242853,490219,937581,741631,763976,854909,282796,1039194,54328,273412,15036,53687,29783,455216,650682,853611,652390,101228,153177,78533,103449,401470,828790,164277,282241,915453,984383,866731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]