SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020678 LIMIT 1 [ RunTime:0.002126s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020678 [ RunTime:0.006089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923306,856957,68501,621632,562219,458184,880649,12789,93111,648306,92666,472083,163705,1017527,830933,915585,400637,108174,633536,489597,182426,44008,996764,561247,85444,29085,579104,612884,1034693,374186,490795,370674,181904,166021,959207,541990,78800,561591,58676,107387,450433,740740,759058,214866,735099,210938,171312,480835,1003531,661806,846808,719978,211359,976552,399726,933282,460556,604544,368608,827228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000967s ]