SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190318 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190318 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915385,661210,410960,532979,1028362,954447,823534,1025929,707380,613277,148704,23275,79658,1002860,994996,185488,79194,583353,118389,394485,132058,624433,276408,1037058,125766,771418,713715,25476,7582,511756,370389,401350,993020,813517,256720,630864,1018274,328844,306308,112332,726255,493283,298477,675328,991978,267494,893999,489686,1017061,1043955,440626,511854,717729,1516,1016104,489664,891956,979985,572583,965524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002079s ]