SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200583 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200583 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623575,882749,207467,78528,696508,710079,756749,647071,449124,803751,844468,247877,564613,80665,484121,203092,565962,590674,182501,614477,448454,974909,135488,363373,791752,167083,157464,672421,941461,175322,879464,960326,53146,661453,472510,521580,772550,1036640,975105,919156,941426,591459,197517,1001602,1009950,116426,838911,825809,771492,744420,554505,1023479,685502,684557,222956,439259,86627,478314,853781,14592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]