SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41940 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41940 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136679,310520,817747,119650,486167,148014,236835,525286,339882,134262,997335,58261,203912,1031641,940028,106416,531017,1047079,144599,146983,1015495,163878,55350,194270,79539,982225,734070,359055,838580,370524,483923,232363,774213,461128,553286,462541,146402,1036256,965897,138256,240633,389288,759862,894777,198335,654666,164983,732627,41661,317439,788723,836411,947261,390013,853255,809352,153262,488448,626640,607845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]