SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008054 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008054 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473627,359083,848933,86821,806353,1035145,283749,879492,56767,474522,463131,327368,413149,414133,104401,341182,71511,466157,681673,335836,557125,272444,702163,576880,307320,362451,376647,611892,987902,103822,663694,308746,208227,112709,669032,84385,324431,584524,182370,437098,495738,93888,250314,488121,667140,943180,345276,280361,1035676,492190,651360,679837,906788,176117,140042,404736,80499,434480,966582,807593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]