SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44510 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44510 [ RunTime:0.003057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537311,32051,611776,805934,746037,116394,239079,940665,24163,728926,1034920,994264,466583,1035107,958106,788210,814127,759378,918845,747725,518496,560937,358461,100956,407141,139765,663704,187720,726628,312407,703497,147874,354789,147273,240985,198313,366129,140322,831100,315616,415810,189179,356553,795691,614912,422930,776800,387098,501514,806212,603418,24379,50007,66909,949317,403913,35234,858180,648518,819594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]