SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574209 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574209 [ RunTime:0.007438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946597,273900,972861,683043,420057,340772,882162,416052,260577,653007,493008,258917,409643,627637,706413,115661,828489,31018,769275,139189,317959,27655,760746,771236,233700,260799,297902,752414,506396,228288,336647,824564,990245,922085,699032,691531,635419,143268,349351,250290,57013,743539,757864,417182,883825,140914,792225,994760,206338,761457,569794,22321,20711,74769,989874,933781,116115,947200,415079,821876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000882s ]