SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670319 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670319 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317800,794330,862333,115437,500142,725445,690502,641023,610728,356250,368229,50625,867099,558294,41458,678330,413787,39240,459507,926505,989844,578027,1031230,211226,802783,169282,429674,838316,415331,872950,438895,252560,40150,159133,518072,886214,193629,583211,584178,763307,531852,695832,917315,959517,740919,20096,849920,934438,527808,991056,799291,897899,252456,211688,116811,384522,705740,464206,640375,603565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]