SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044240 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044240 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605834,912018,198515,446292,252179,629857,858121,843341,51943,114077,830942,779145,246547,451844,127829,700899,21791,243811,552732,797146,677683,170588,783602,271369,790779,752440,221615,615270,975140,109008,907193,279341,965324,441497,996484,557175,351710,667016,596329,148206,490545,633409,522137,18477,133886,284801,242781,673660,817637,1510,688822,81081,117910,1013492,969726,425877,926768,74649,676905,1038053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]