SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000940 LIMIT 1 [ RunTime:0.001943s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000940 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462904,732794,517834,779341,245306,1026087,968899,303981,481634,509065,434100,700633,538380,941543,813128,669813,557175,3779,29152,490893,713271,797362,497512,223685,580404,1047049,637620,529246,842415,787484,807826,516277,777655,742327,866596,911817,362965,659629,1028193,58527,966336,144046,327861,1000166,1023597,243938,249843,215631,363351,720626,262129,211889,636787,305536,72676,478472,857493,966592,22937,352195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003861s ]