SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831041 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831041 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371527,124006,1019050,338105,164631,200675,10548,171388,70596,500785,130840,871316,101964,670357,970888,435087,425275,892753,251614,704120,137999,412584,2857,458392,289720,732583,401488,665857,26360,108802,951003,273232,695272,309742,407481,601391,501106,656345,84670,410833,110319,608142,65018,388211,224823,635007,96432,55391,527648,794532,723745,534509,1000843,422335,774451,385818,159889,882119,260280,26465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]