SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529183 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529183 [ RunTime:0.003713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518369,59261,771822,686059,848491,926944,1000496,836848,778056,1011181,24924,262149,576895,332823,831892,1012120,1048637,93206,400533,722562,303098,193102,1017615,751083,303553,526904,220487,483451,718980,540055,582887,898324,73197,987587,872434,239692,528151,144487,120975,860425,417428,846228,592138,895839,973644,828449,496154,273917,783669,1015779,633199,301536,573656,682793,825796,706210,825046,194440,247247,53153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]