SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036502 LIMIT 1 [ RunTime:0.001779s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036502 [ RunTime:0.001294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192042,259327,467981,408221,610215,406162,922443,497002,980073,569099,264141,375274,605491,834568,95865,148977,171190,847334,208407,124882,141331,552654,252423,471283,668551,636750,810809,123030,74186,605715,955755,825210,323230,485837,1015666,91929,469113,367684,1036694,40226,408464,203996,509370,243685,265105,27156,771327,20675,79782,614238,681820,517484,15228,911638,28512,292874,422540,270068,338411,242512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]