SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442168 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442168 [ RunTime:0.001452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247870,519956,400018,228276,251595,342312,516590,524887,95004,823795,336687,920412,213476,255164,94005,579140,932804,570345,813329,903975,418310,317072,514278,881829,447824,498387,234410,953471,434119,703740,767294,709268,823277,193296,666160,192039,709043,244643,261863,687892,494816,447006,97471,721045,425408,220701,503868,627465,339106,299337,884300,508477,588831,143026,102563,122360,501340,107990,709633,453393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]