SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454217 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454217 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352088,478129,924434,880378,490813,220006,709268,398762,369868,981856,677653,677715,451959,238494,199516,993628,51450,169769,61757,738707,426477,314045,1023785,423626,932464,94476,929878,110035,1013735,262543,850578,624191,39270,720318,284662,632286,96714,941376,779272,25703,565740,222404,85191,870007,577573,657094,895395,749935,322093,522781,655473,596996,771272,399421,292169,556266,676552,131476,536167,1043000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]