SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335307 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335307 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58695,853285,1028944,522371,446035,746691,236253,628936,924986,103955,9619,310494,245150,600764,769370,121917,857985,535821,134004,918370,900366,905860,705673,903227,981068,271958,918710,71675,400112,214652,478561,827221,873455,718063,749006,126903,595451,438558,749407,1024839,356232,816490,143194,762848,109725,749140,990782,972761,659959,850096,263427,283165,1017806,21500,120605,837297,521224,514378,965987,270707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]