SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005122 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005122 [ RunTime:0.001431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039744,415768,116298,37471,137736,184381,233802,247153,679889,735995,443088,776744,1034355,1005188,138719,40694,747291,294521,236864,461775,585266,643384,237683,542766,558233,567164,24865,102581,766432,731428,446523,1016182,498394,826878,93737,1030965,538560,360439,282999,25254,374289,148160,1017519,358988,618994,989928,280950,405711,781079,592949,23965,58031,495069,411499,82287,216898,1033261,447167,199623,985003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]