SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195001 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195001 [ RunTime:0.003216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667536,907384,529819,298855,718464,1011012,556015,393975,517026,4841,324730,52529,153299,821481,545125,672537,715310,1028334,731219,543139,477903,927523,759532,117279,686624,642422,488799,224268,774701,271603,358691,87284,490972,912893,27258,16387,378070,554273,564978,368034,212717,1037963,718194,269110,352247,58069,273862,888923,845408,149125,712167,732316,503893,450313,1046635,380371,341154,749425,442200,741955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]