SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26766 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26766 [ RunTime:0.002555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952578,591078,49058,1017495,239324,863917,766527,457911,597261,220742,783732,859758,313656,493829,900231,30540,317237,516054,653883,111315,740809,480964,216343,122759,1005333,657961,153940,330667,385763,355505,977811,987995,796708,443807,614876,1032829,274004,892034,215185,200821,546030,788079,1047386,568338,441369,526271,472821,74945,710896,162029,469571,554013,914702,814739,565536,396883,319763,190975,242382,241169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]