SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595594 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595594 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117142,958518,329359,719628,968874,942588,305338,889461,543591,657308,260751,82564,302134,229057,869091,731359,577447,130430,555809,332891,922918,423185,681841,4782,338024,596088,392216,420104,102364,327878,996043,540659,347402,699678,755629,915935,760491,585832,407971,796095,476694,111483,1005663,437608,238311,916352,306973,659346,953820,402434,1003509,83246,604607,592838,334141,926580,100553,240174,852635,883851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]