SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500931 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500931 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148882,74417,812804,805462,643664,717788,279665,20779,204271,448969,261107,456014,21719,648320,982308,645963,90562,696416,305230,9357,435749,37551,923434,744114,572440,581759,896368,683106,310525,772109,326848,123886,537788,63907,774540,512463,740789,494048,50529,931039,347008,714995,375658,144181,171100,352073,969152,377184,748998,55312,366989,1016830,803661,133052,525053,945702,527743,973133,458094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]