SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044324 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044324 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497302,1022683,418225,673984,931437,541054,39818,228378,268842,613356,710585,292636,357214,126666,780900,205755,498038,477317,440036,805637,45495,548090,724367,784478,140373,112668,488025,473486,869012,711476,408158,658938,818038,806699,637064,878966,209040,343888,119647,493594,450154,887447,373351,155594,264508,693351,248575,295632,615944,990478,238000,30096,118857,129312,431435,505306,186523,435177,209385,701458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]