SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418741 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418741 [ RunTime:0.004138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817196,603782,709652,236367,859873,939904,856930,327033,728937,223440,618712,562453,353916,822544,719924,1006529,465705,521843,473277,1003844,330265,1048812,986631,80507,685334,536517,669922,107935,716447,109654,988648,888818,539370,557151,631180,339699,537315,855199,725358,182857,194518,303052,404888,249760,379260,347154,1038852,500600,712673,274449,937163,837092,841074,405689,571002,744443,835495,592732,17513,89093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000875s ]