SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036204 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036204 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414014,374935,820561,758387,904002,230184,591211,976216,603092,397358,738027,141721,682102,308000,622947,921690,842333,538893,170298,933864,637910,427472,444488,813654,662429,86962,1016013,204679,389972,151422,114622,1045191,845649,871250,72426,241990,399864,761267,853344,632501,444507,168603,811763,993879,48105,333765,116342,493471,848702,676592,607654,908559,745377,789507,666275,294349,324857,695007,768526,206154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]