SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671460 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671460 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044632,1042990,235655,200760,997070,527616,206788,945382,402690,21158,964642,312281,988429,707323,340702,886008,741659,20146,1040539,45519,204978,803099,544976,899981,527393,592900,955779,317585,757036,3107,729863,787511,1013476,789739,81957,478894,1048885,486293,117975,809849,440877,735061,517912,594281,173613,480491,543619,578766,306976,744725,122245,486572,919437,603852,306114,637186,229367,239724,103398,730290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]