SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401211 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401211 [ RunTime:0.003698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660684,1015381,89925,1007362,95288,548991,530148,984310,924654,891413,117547,655319,260298,405847,277353,875161,675462,840858,69944,464195,770987,15572,330351,609730,725581,1043711,635812,968247,222936,9219,636558,97461,95792,192567,530179,1029489,605246,25366,66740,978781,113808,518214,519436,711073,1028695,1023521,504965,752001,72078,851404,113800,474483,653902,995661,580602,555603,21221,22260,21880,897200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]