SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004896 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004896 [ RunTime:0.002818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274416,7333,985906,916103,675810,576045,1006194,645309,766150,454267,1046667,207416,521932,445237,1042535,918613,512276,485360,182683,826226,969529,1037445,310317,258809,369358,724711,841022,949923,698397,865994,283301,859474,356368,925291,295265,786140,850466,720023,217109,567468,543948,586510,358341,731156,889930,272319,592577,950187,251560,374127,804666,353208,888899,769511,373955,317888,287532,181943,978279,77219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]