SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 202060 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 202060 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010259,122510,19945,322962,350857,774116,709217,975874,765194,823652,45465,80795,28758,882706,802797,807473,720907,483199,600623,548430,494462,973392,907633,351263,985503,768251,437466,726336,1023055,852146,516696,1023379,388879,261990,159116,955531,60384,774491,572766,987599,81567,228513,790568,831770,745491,494939,595187,684956,1044378,153362,803079,8095,217859,758356,604828,986789,442104,904134,134310,34790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 202060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 202060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000985s ]