SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414636 LIMIT 1 [ RunTime:0.000767s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414636 [ RunTime:0.003346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575810,599599,159621,875209,853188,257090,6931,698094,207313,694726,605011,623286,452609,728658,602038,535639,976703,1027706,214451,1001973,828034,933496,311531,786753,910803,127835,354213,1016742,751719,988370,150451,966871,223051,110989,481813,258794,460762,350174,260243,215711,859066,346024,624370,404816,997698,14261,308051,887862,513055,534807,832444,771633,795471,392742,714545,482780,869737,185973,654818,113265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]