SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45515 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45515 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240890,424863,1001235,946348,951692,677566,941265,6537,1009837,249900,790241,742891,694497,1046599,108633,297678,215761,876470,95482,40127,815359,392688,745770,617118,168169,27853,223534,5218,298036,705611,923377,1008591,141495,99915,377898,979348,2974,650065,936585,275062,989131,706867,149762,529167,350369,231813,806445,743237,584294,808767,643583,672798,123803,968113,365247,713317,16681,305659,774629,200355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]