SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523160 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523160 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401718,840212,494189,872931,209467,828422,426208,904090,327860,1036842,1036007,872001,875652,697437,130876,323908,682479,499797,228849,969693,558811,1009412,622944,854971,1018498,100908,107844,294079,368376,236747,703880,1025381,165042,72843,266161,279135,731465,427920,974489,680772,869209,117660,15439,412913,27580,780293,124064,546177,418785,674754,1029376,306415,995869,540909,313510,75376,104653,932957,389227,945783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]