SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343204 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343204 [ RunTime:0.002041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396298,63211,105892,449774,174496,43554,451949,297706,382173,983510,660307,424797,898042,462750,104294,344533,855435,209486,416585,644976,892302,480936,245452,892380,765117,231104,740705,474530,740660,751622,781073,971574,606520,233526,41580,172005,179394,747186,213786,160764,416782,1022926,598202,797345,766373,970827,174589,999252,823615,856804,679414,558431,232086,733340,48637,879690,959652,472859,357185,1048814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001899s ]