SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047223 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047223 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341340,13905,284459,394615,909080,476617,851527,388511,774884,298111,1015247,7440,914361,404256,1020957,299648,482939,1035008,794752,112373,870840,486657,437910,278433,4408,74103,17712,122900,865526,274478,692739,588840,766278,425422,12581,348931,535775,286523,505087,857034,116056,845135,32078,922316,609921,278647,903081,604806,465262,289819,752272,284961,779074,889084,232719,781808,484020,876944,1015754,25477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]