SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038486 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038486 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988469,546224,555352,3083,765486,121303,546770,442959,886150,835087,630972,808044,183986,314611,498232,101372,647574,757598,33265,526273,343691,30667,134476,896660,158120,455962,163669,573576,515976,534267,1011869,5992,1030487,79602,368333,67875,949104,663843,84194,713625,660175,578076,661327,673958,352976,609268,433461,527784,81911,250788,778104,706068,649613,957161,2122,160966,618881,894580,323213,39500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]