SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047822 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047822 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38859,348886,289846,770479,774862,542680,606906,547339,671366,540171,771173,146892,277007,391571,133179,220467,206007,195092,996077,763188,233568,813747,182910,46699,859408,395061,29934,871868,87606,640096,121384,742229,261360,126741,555727,500003,146344,617317,704881,600309,870409,653671,778589,871276,467846,393690,673746,218097,327908,807765,1030255,767846,423767,227260,276693,363533,282593,736291,504536,710784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]