SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981075 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981075 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883832,663218,863133,223450,1030333,951907,925528,743998,813881,922966,745922,427398,219052,26571,299665,143012,835757,208728,987168,290661,451718,152440,199462,914276,572897,581529,859669,553070,697510,609628,1026367,947458,416180,868950,126961,161710,794064,845810,29898,129097,1039901,990354,68440,724196,1029402,256228,286182,555838,679470,517070,37572,939568,515378,506246,1033127,296218,878276,224369,233082,952793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]