SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480575 LIMIT 1 [ RunTime:0.001108s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480575 [ RunTime:0.004271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17529,875171,206640,566296,657767,84063,396833,731416,465353,328772,863825,366935,316012,433174,490531,9901,868418,636778,401624,366742,978521,1023787,79199,912128,257772,281817,250105,604892,1014007,980813,986281,384068,634130,542701,999409,27031,678803,425209,341435,573627,18475,690196,889146,580922,1027306,912935,421718,812054,404198,74133,62741,463170,526360,980812,630230,986016,344974,603640,795851,330581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000900s ]