SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358193 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358193 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452867,388974,816345,489106,463201,855188,624602,242083,150632,462730,421185,938540,34553,452948,578144,940288,211439,88140,121641,1004356,800671,1048120,910475,75720,668340,824123,373794,958043,156192,937108,678850,399634,301801,126122,919551,621161,960567,953881,886101,384603,778031,903530,883813,828601,422106,412879,360437,351504,151246,844664,230782,673675,514683,188087,108387,426839,831407,371742,739025,728533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]