SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501559 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501559 [ RunTime:0.003822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888865,69293,995546,415182,811420,1028839,556724,536003,304093,116585,872926,194712,747546,776726,585947,21533,652586,649465,1034009,839407,206377,802848,722271,304737,1039016,584870,1026647,837788,850857,497058,555581,778095,236072,128878,657278,440854,37729,587592,671555,262401,1015021,566337,396868,70314,115318,856241,282765,623459,22674,697461,381364,672729,444713,979421,621347,398671,809434,463769,839369,881365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501559 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501559 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]