SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559024 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559024 [ RunTime:0.003147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528450,612514,675155,789205,1029527,502150,146284,698693,734176,24141,722597,47127,131979,640755,38438,246532,1047588,740549,726899,317473,297858,1005513,660581,706252,345089,982870,1025718,793655,488241,816655,352958,330745,347877,86526,286493,182234,191592,704603,345492,482929,316797,355677,414455,675232,501970,511546,535467,377599,163770,929539,375356,677053,957562,194723,82901,432776,642895,420114,320315,418530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]