SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415253 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415253 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713438,842169,507153,257498,438531,86428,217333,194100,96155,411616,698929,905232,380341,176978,73521,702512,443241,9542,729728,810196,290059,949899,718642,999130,299756,801239,103336,397956,617567,842037,760445,550275,333006,281057,811293,999714,757816,559414,165337,256794,675743,295180,317498,857624,385443,21701,979165,65196,534264,87698,154980,246804,526723,179071,493103,1009225,277198,718264,658956,813470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]