SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492513 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492513 [ RunTime:0.002661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28877,686041,372223,119761,1017590,867491,840822,683457,42120,126524,15208,814711,8163,838952,804599,418853,349042,179585,573328,854134,787205,1022547,979523,275285,333687,620075,697069,518316,828371,129734,494090,735226,1020220,790587,972751,801652,489964,77675,738015,259490,700317,187992,764924,454086,852214,1005132,296908,297936,667625,1005311,625827,140516,162502,825864,814713,353219,713733,246593,421097,621108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]