SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564252 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564252 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252637,998384,124550,821006,183163,862537,520841,104122,646133,319627,862291,213642,403030,469789,453130,199317,658306,547766,955184,1027218,594305,496456,27161,428918,708643,771344,921122,842316,900298,516328,780355,404870,502290,995169,750335,639863,641060,553267,260567,317854,192437,666432,412861,727875,80229,846298,897558,177948,831650,600807,693868,991031,794358,802376,197267,251818,505686,318043,844061,634140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000825s ]