SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423799 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423799 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302574,756846,274735,547718,1023033,578221,351334,835674,549103,87255,17524,962851,140456,877671,14389,141784,280475,74982,318498,303130,241726,818812,87479,392455,976097,474767,570032,540297,345206,335970,610503,744175,850467,403289,851578,1021782,148624,339516,1029327,378259,490540,244218,851798,573314,151124,54274,241720,99686,894089,261843,70572,776650,827006,878635,256409,828722,114964,401634,360342,98524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]