SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409838 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409838 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628557,212368,518043,11381,120641,609451,812938,660057,39793,797495,373209,622260,74089,1009398,286628,319123,886161,194268,82561,601514,349088,463745,276853,837420,361762,67690,81216,212470,408163,404684,843528,432108,50701,62353,982284,716426,194867,83844,287850,728297,585031,949290,127138,141358,256418,999790,732716,859512,62567,123423,123048,894490,604536,632851,1005556,867880,316565,457157,972197,1030353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]