SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454711 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454711 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832035,373247,776710,180716,522409,147160,65398,535189,140290,352735,857903,92198,762217,281526,575424,739761,783443,182362,971530,500309,1047436,287152,1005995,661489,255151,289796,483573,123896,409390,507460,51207,833894,25683,278660,573317,583682,626510,220985,687346,876240,668695,203658,690880,369029,64335,837160,1026326,811768,1043420,220303,561689,869874,293783,915983,531426,1003221,1044014,527836,963378,4904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]