SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468336 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468336 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951798,534851,163200,501215,81867,99910,299244,249471,619761,1011865,397628,406773,106190,592053,26560,558671,1019167,170460,830725,950807,776130,619260,70649,683400,447201,534987,501021,718893,811822,801414,946497,910532,430116,472665,601859,531195,753549,520878,89186,348950,941461,370258,10371,233448,787423,38142,933561,731476,909018,242281,255707,312704,238676,600405,119178,327709,396261,969185,816145,916240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]