SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419969 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419969 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112882,560250,146792,474031,680428,772005,695981,64396,286545,886416,847297,602750,783804,466195,254443,184490,785376,954056,781788,629197,541262,244857,606911,980587,471394,65209,986126,1007947,401453,488446,200816,191779,920672,659167,454049,642947,1022770,494073,175114,687937,256608,989076,152170,413608,391306,283853,252859,971593,646891,474978,1024106,237303,729859,590924,857225,990876,104566,708638,1034496,617109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]