SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48002 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48002 [ RunTime:0.002863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561720,124710,950392,982148,1022784,305308,722660,112517,987033,257684,480788,88628,103196,233183,331527,160507,254124,698583,943464,1022631,453839,865091,92086,964515,691484,450111,461543,328005,918685,566265,270768,661373,541736,579638,262087,480477,905220,275010,684573,861553,472448,7824,799276,338002,221688,652054,77104,953249,254730,626735,902352,53117,144897,437164,441165,571800,318607,120104,575794,979634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]