SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47203 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47203 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017345,986012,393341,114676,848509,258807,1014826,406655,570761,708654,223171,188634,316623,29353,311138,333966,412619,792774,747313,161223,7636,775257,1017634,879283,1037244,314202,199676,548271,40207,1009650,233402,1011375,427082,306923,193760,520138,327120,793124,1048023,817096,83398,754508,842892,432336,292981,225291,702831,77396,878348,968765,745005,835635,708728,791018,195559,533795,839261,446096,214702,938857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002283s ]