SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985303 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985303 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343423,730099,964724,749591,311925,689396,280067,925384,840668,696556,705361,277461,576911,889068,313252,89708,207561,415367,657919,312005,743577,1028746,781206,343241,858978,370001,806234,230406,637842,207794,592614,461490,1033878,638216,143172,152050,463407,596625,20464,545200,189154,263816,660889,880197,218939,829630,479680,916648,692042,967420,714787,306084,250708,556969,1040530,511751,917858,913415,380475,1025001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]