SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581784 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581784 [ RunTime:0.003492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610128,401726,335105,614853,244902,666327,424354,955162,821289,284688,443280,807059,133206,542453,302500,60775,542324,376422,946240,188198,492071,324223,723862,338889,571998,396049,418932,330273,168660,317906,241883,147117,298200,70728,127168,350187,466484,284022,752611,202299,979452,407099,940841,408754,892884,278511,140800,246864,48498,68579,341387,892433,57005,415423,498884,513650,148486,356222,521585,267247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581784 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581784 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003305s ]