SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400018 LIMIT 1 [ RunTime:0.000881s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400018 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11462,663399,335962,583830,92592,392729,944325,119654,92498,131210,594000,1018842,699146,458045,833181,88201,113382,442798,435600,662046,573182,991344,969190,545431,769826,519814,486877,336007,157223,545173,924885,5356,108792,853709,823961,431986,964655,677867,842381,297919,302330,681300,430524,687412,602814,936694,448917,616284,432016,800441,996702,64675,38804,369549,11811,381457,729200,556803,250432,726694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]