SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414615 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414615 [ RunTime:0.002938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463930,745103,916970,97566,868430,872621,243748,507057,947316,552610,453469,539214,543454,454846,118170,401084,868302,719387,811924,265158,809911,760973,841551,290956,149862,317503,2391,348847,102092,1016025,875479,682080,880208,531456,943928,300439,318377,980195,837687,87761,982794,853261,206283,494315,699866,185961,514892,792708,871357,597444,235106,283268,618287,276112,623720,405810,74436,372027,401100,961968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]