SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490084 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490084 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016092,649856,783087,321967,263553,95546,591783,556998,630937,990252,727919,642559,484165,645424,86221,575870,199702,158519,396191,451463,25930,694902,1032609,965758,25098,586461,528450,984600,353571,441701,126605,536225,847654,820546,181783,106810,356383,824767,48141,814870,753355,967482,773118,99707,63349,760181,129481,988435,794583,646658,898509,638419,399850,485654,3043,470753,461746,761618,526882,513235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]