SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502169 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502169 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522498,220337,296950,393475,938052,107770,809978,926175,647686,957541,813734,467889,56852,556878,258360,992167,946807,776819,152466,631773,309179,969338,791213,627836,606733,52518,266440,762228,708402,990969,597980,669565,572626,494688,298028,1037162,633269,655667,292593,138260,580551,658293,563664,322841,972070,598653,870275,257451,607072,831877,489648,450282,651822,674266,953340,3045,746209,170969,111750,110594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]