SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392051 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392051 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765412,401992,583837,931740,816921,156799,1043244,770743,610945,390410,681522,893295,243864,466927,227709,192375,81959,284582,716592,867221,913933,803125,883498,322681,284805,710695,768238,673407,658886,1015806,1041065,1028067,919099,208941,188204,924959,20334,846674,215636,284164,737838,177505,990451,998560,231151,743490,58562,434659,172787,478668,150466,243322,124028,271070,385431,631730,435436,309131,1217,1019788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]