SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026864 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026864 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591862,478463,454015,643399,810408,525812,226344,335232,507694,88871,78400,354079,975631,709017,995440,17029,895491,680138,981442,1022455,304240,1036496,229521,66837,661509,511752,210397,88929,223265,324780,329242,308231,436414,744932,175897,706937,659095,954205,946259,112281,355704,349290,599267,906706,914502,125230,625406,573583,995452,534822,951427,890921,164447,528660,858785,198741,416656,275835,890397,85059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]