SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364040 LIMIT 1 [ RunTime:0.000662s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364040 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299872,1013754,778550,632718,726057,732784,561171,392842,929333,813792,25939,89268,779056,979774,42559,832506,708290,741795,196773,98488,978478,877274,704536,149929,824443,708300,124582,612059,315773,169761,12634,253,479247,209970,559874,611141,135938,687003,286357,811173,282827,182685,519303,73439,739215,379613,307524,74589,600541,62956,182171,857688,708006,438832,198925,581140,703112,670667,740584,833939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]