SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446213 LIMIT 1 [ RunTime:0.002067s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446213 [ RunTime:0.003080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394541,588364,190595,162550,495874,429871,195045,747495,103640,393387,814881,28273,611289,1022353,536827,261653,426025,666219,629329,394698,1036752,792786,653158,578030,58925,897073,527202,492660,200614,838546,1003726,771952,276725,654278,379494,633762,1040507,363286,423556,60575,614564,697877,360889,443803,213629,568908,839453,206154,974392,427846,738801,649492,811966,910706,493010,292162,576625,840715,782167,484850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]