SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804211 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804211 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157254,981963,347683,741051,439061,892299,832429,351444,34562,725988,442876,305883,427860,724379,345634,596684,440091,357276,1016996,209049,276757,1010496,888495,348851,722218,489128,207405,163751,879833,407618,349427,23523,542759,381473,557275,767963,196981,617583,73508,778988,121441,821370,843040,126921,558914,337210,242887,202219,301978,743975,186718,421661,615944,736090,354221,126628,261095,503574,964405,832917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]