SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974597 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974597 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408048,1020625,75739,571350,970655,49204,18655,786977,715853,482594,105654,570451,276774,707551,145153,618600,718805,1047862,337576,854937,300330,847223,1039280,626186,316535,435763,922912,1047382,274156,366667,730494,394644,281689,73200,566215,1028855,993877,489353,471903,176672,282348,408514,30210,744607,956133,698530,940968,444848,210864,713561,731309,407297,415464,887966,87035,639902,608633,795586,1031065,103293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]