SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454213 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454213 [ RunTime:0.003693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748310,568207,729716,736180,859181,685948,975376,766391,919480,447412,383330,340206,562845,342405,65940,873560,161915,387019,365241,612578,96381,298959,802377,147168,810901,1023628,153139,454371,802662,939173,690327,837157,815435,675224,89579,704295,77460,299859,363682,626362,973193,942226,130076,179844,965628,957503,846627,1005530,908232,840501,1009383,369519,545155,43714,644062,653785,351419,128731,913403,362844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]