SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504823 LIMIT 1 [ RunTime:0.002808s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504823 [ RunTime:0.005943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692525,1003441,692123,1028283,934794,880881,756621,60487,363045,896957,394212,992673,17921,1047169,454771,971231,799847,357527,877101,84570,621708,556325,697961,337833,177977,122558,24608,176603,458744,27076,564531,351451,377599,923784,432931,212171,683650,878308,688641,705436,89982,597658,110712,767130,998986,661867,59002,18748,55007,660267,79646,584515,145320,500396,986196,1033002,57711,104955,614328,791130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]