SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104123 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104123 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027504,406433,339762,815437,353661,872137,487332,643752,236532,674562,22731,395323,847804,379949,239100,509070,485205,885532,25986,382256,46529,298632,103657,754909,876649,491220,920042,324466,372540,65164,31226,483777,709653,382883,553583,280433,709876,165578,390189,841195,453568,37870,382983,306685,700770,519631,736972,198890,274203,982131,395868,778670,754029,407954,165370,1023744,856983,245656,76653,560486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104123 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104123 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]