SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474703 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474703 [ RunTime:0.002812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706880,173119,463226,492150,503630,182246,776791,183121,281852,601510,864359,217522,992929,535195,404084,257963,66539,49098,502547,932844,583459,272406,754243,760241,64221,370971,249824,833128,694871,355007,855748,847231,419121,930460,345566,550522,26422,800837,1008367,193091,402825,339871,115413,820954,943400,380660,461364,1012235,405339,441575,494265,908815,362652,779200,87400,434235,416804,795034,928512,769753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]