SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581991 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581991 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854427,425650,106656,934453,151934,910261,549798,856587,195673,691175,713436,117097,49969,250523,108852,910038,735895,553182,300230,613089,192327,789040,349443,360974,814869,468937,798448,113548,800662,781002,44454,525772,862348,527660,146404,110845,1040093,663816,508833,133839,324403,172650,455907,909193,792662,712636,802276,419592,372838,381730,1031933,265139,169761,1019183,249901,12215,675235,706593,22419,975737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]